CREATE TABLE [dbo].[article]
(
[id_article] [int] NOT NULL IDENTITY(1, 1),
[ref] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[designiation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[client] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[famille] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[grille_taille] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[serie_trait] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[vmp] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[prixfacturation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[image] [image] NULL,
[observation] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[article] ADD CONSTRAINT [PK_article] PRIMARY KEY CLUSTERED  ([id_article]) ON [PRIMARY]
GO
